<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>

    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=no, maximum-scale=1.0, minimum-scale=1.0">

    <title>  首页 Index  </title>
    <link rel="stylesheet" th:href="@{/css/base.css}">


    <style>
        a {
            margin: 12px;
        }

        a:hover {
            background: #000;
            color: white;
        }
    </style>
</head>
<body style="   ">

<div th:replace="~{common-page/header.html :: myHeader}"></div>

<img th:src="@{/img/TEST.jpg}" style="width:123px; height:123px;  "/>


<h1>首页 index ( 记得新建数据库 ) </h1>

<div style="">
    <a target="_blank" href="/test">ResponseBody-test</a>
    <br>
    <a href="/all" target="_blank">all user </a>
    <br>

    <!--  <a target="_blank" th:href="@{/database}"> 查看数据库 url </a>-->
    <!--  <a target="_blank" th:href="@{/select/config}"> 查看配置文件 application.properties </a>-->
    <!--  <h2>数据库测试:</h2>-->
    <!--  <a target="_blank" th:href="@{/select/show_databases}">1-show databases (测试数据库链接是否成功)</a>-->
</div>



<h2>插入一些测试数据, 测试数据库中文和 emoji 是否乱码 </h2>

<pre style="font-size: 24px;">
-- MySQL 8 默认编码  utf8mb4
CREATE DATABASE IF NOT EXISTS `db_emoji_test` DEFAULT CHARSET utf8mb4 COLLATE utf8mb4_general_ci;
use `db_emoji_test`;

CREATE TABLE IF NOT EXISTS `tb_user`(
`id` int(50) unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT '主键',
`name`  varchar(200)  ,
`age`   int(20)
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO tb_user(`name` , `age`) VALUES (  '张三' ,  23);
INSERT INTO tb_user(`name` , `age`) VALUES (  '凯奇' ,  66);
INSERT INTO tb_user(`name` , `age`) VALUES (  '张洁' ,  35);
INSERT INTO tb_user(`name` , `age`) VALUES (  '汤姆🥵👿👻💀' ,  45);
INSERT INTO tb_user(`name` , `age`) VALUES (  '杰克😅😎🥶🤡🤖🤟👈' ,  56);
select * from tb_user;
</pre>


<br><br><br><br><br><br><br><br><br>
</body>
<script th:inline="javascript">
</script>
</html>